package com.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.pojo.Product;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @author lifeng
 * @create 2022-11-28 23:32
 */
@Repository
public interface ProductDao extends BaseMapper<Product> {

    //根据商品id获取商品价格
    @Select("SELECT product_price FROM t_product WHERE product_id = #{pid}")
    String findPriceByPid(Integer pid);

}
